 CREATE EXTERNAL TABLE jms_dm.dm_tab_business_monitor_contrast_dt
(

   statistic_date                date comment '扫描天',
   statistic_hour                  string comment '扫描小时',
   statistic_format_date           string comment '格式化时间',
   scan_cnt                        bigint comment '扫描数量'

) COMMENT '操作平台-商务件监控对比' PARTITIONED BY (
    `dt` string)
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_tab_business_monitor_contrast_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );